JSP(홈쇼핑회원관리프로그램)_2024-09-13
DB--1.회원정보 명세서CREATE TABLE MEMBER_TBL_02 ( CUSTNO NUMBER(6) PRIMARY KEY, CUSTNAME VARCHAR2(20), PHONE VARCHAR2(13), ADDRESS VARCHAR2(60), JOINDATE DATE, GRADE CHAR(1), CITY CHAR(2)); --2.회원매출정보 명세서CREATE TABLE MONEY_TBL_02 ( CUSTNO NUMBER(6), SALENOL NUMBER(8), PCOST NUMBER(8), AMOUNT NUMBER(4), PRICE NUMBER(8), PCODE VARCHAR2(4), SDATE DATE, PRIMAR..
2024. 9. 20.
JSP(지역구의원투표소프로그램)_2024-09-12
DB--1.투표이력테이블 명세서CREATE TABLE TBL_VOTE_202005 ( V_JUMIN CHAR(13) PRIMARY KEY, V_NAME VARCHAR2(20), M_NO CHAR(1), V_TIME CHAR(4), V_AREA CHAR(20), V_CONFIRM CHAR(1) ); --2.후보자테이블 명세서CREATE TABLE TBL_MEMBER_202005 ( M_NO CHAR(1) PRIMARY KEY, M_NAME VARCHAR2(20), P_CODE CHAR(2), P_SCHOOL CHAR(1), M_JUMIN CHAR(13), M_CITY VARCHAR2(20) ); --3.정당코드테이블 명..
2024. 9. 13.
