학원프로젝트(Dayiary)
테이블 (27)
COUPLE_ANNIVERSARY
- DAY100 — CHAR(8 BYTE)
- DAY200 — CHAR(8 BYTE)
- YEAR13 (DAY300) — CHAR(8 BYTE)
- Field (START_DATE) — CHAR(8 BYTE)
- Key (RELATIONAL_SEQ) — NUMBER(12) — 외래 키 → RELATIONAL_USER.Key — NOT NULL
Copy Of Untitled (PRODUCT_FILE)
- Field (FILE_SEQ) — NUMBER(3) — 기본 키
- Key (PRODUCT_SEQ) — VARCHAR(13) — 외래 키 → Untitled.Key — NOT NULL
- Field2 (FILE_NAME) — VARCHAR2(100)
Copy Of Untitled2 (MENU_FILE)
- Field (FILE_SEQ) — NUMBER(3) — 기본 키
- Key (MENU_SEQ) — VARCHAR(13) — 외래 키 → Untitled.Key — NOT NULL
- Field2 (FILE_NAME) — VARCHAR2(100)
G2_SELLER
- Key (SELLER_ID) — VARCHAR2(20 BYTE) — 기본 키 — NOT NULL
- (USER_EMAIL) — VARCHAR2(50 BYTE) — 외래 키 → MAIL_PASS.USER_EMAIL — NOT NULL
- Field (SELLER_PWD) — VARCHAR2(20 BYTE)
- Field2 (BUSINESS_ID) — CHAR(12 BYTE)
- Field3 (SELLER_SHOP_NAME) — VARCHAR2(150 BYTE)\
- Field4 (SELLER_PH) — VARCHAR2(11 BYTE)
- Field5 (SELLER_ADDRESS) — VARCHAR2(200 BYTE)
- Field6 (REG_DATE) — DATE
- Field7 (STATUS) — CHAR(1 BYTE)
G2_USER
- (USER_ID) — VARCHAR2(20 BYTE) — 기본 키 — NOT NULL
- (USER_PWD) — VARCHAR2(20 BYTE)
- (USER_NAME) — VARCHAR2(50 BYTE)
- (USER_NICKNAME) — VARCHAR2(50 BYTE)
- (USER_PH) — VARCHAR2(11 BYTE)
- (USER_GEN) — CHAR(1 BYTE)
- (USER_BIR) — CHAR(8 BYTE)
- (STATUS) — CHAR(1 BYTE)
- (REG_DATE) — DATE
- (UPDATE_DATE) — DATE
- (USER_EMAIL) — VARCHAR2(50 BYTE) — 외래 키 → MAIL_PASS.USER_EMAIL — NOT NULL
- Field (USER_ADDRESS) — VHARCHR2(200)
MAIL_PASS
- (USER_EMAIL) — VARCHAR2(50 BYTE) — 기본 키 — NOT NULL
- (RAN_NUM) — CHAR(6 BYTE)
- (STATUS) — CHAR(1 BYTE)
- (PASS_DATE) — DATE
RELATIONAL_USER
- Key (RELATIONAL_SEQ) — NUMBER(12) — 기본 키 — NOT NULL
- (RELATION_DATE) — DATE
- (STATUS) — CHAR(1 BYTE)
- (USER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- (USER_ID2) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- Field (RELATION_TYPE) — CHAR(1 BYTE)
USER_ANNIVERSARY
- Key (ANNIVERSARY_SEQ) — NUMBER(12) — 기본 키 — NOT NULL
- (USER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- (ANNIVERSARY_DATE) — DATE
- (ANNIVERSARY_CONTENT) — VARCHAR2(300)
- (STATUS) — CHAR(1 BYTE)
- (ANNIVERSARY_TITLE) — VARCHAR2(100)
- Key (ORDER_SEQ) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (FAVORITE_LIST)
- (USER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- Key (R_SEQ) — VARCHAR(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (PRODUCT_SEQ) — VARCHAR(13) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DELIVERY)
- Key (ORDER_SEQ) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (DELIVER_COMPANY) — VARCHAR2(2 BYTE)
- Field2 (ORDER_ADDRESS) — VARCHAR2(400 BYTE)
- Field3 (ORDER_NUM) — VARCHAR2(50 BYTE)
- Field4 (ORDER_MSG) — VARCHAR2(500 BYTE)
Untitled (ORDER_REVIEW)
- Field (REVIEW_CONTENT) — VARCHAR2(30 BYTE)
- Field2 (REVIEW_SCORE) — NUMBER(2,0)
- Field3 (REG_DATE) — DATE
- Key (ORDER_SEQ) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MAIN_BOARD_FILE)
- Key (FILE_SEQ) — NUMBER(3) — 기본 키 — NOT NULL
- Key (BOARD_SEQ) — NUMBER(12) — 외래 키 → Untitled.Key — NOT NULL
- Field (FILE_ORG_NAME) — VARCHAR2(100 BYTE)
- Field2 (FILE_NAME) — VARCHAR2(50 BYTE)
- Field3 (FILE_EXT) — VARCHAR2(20 BYTE)
- Field4 (FILE_SIZE) — NUMBER(12,0)
- Field (REG_DATE) — DATE
Untitled (MAIN_BOARD_REACTION)
- (USER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- Key (BOARD_SEQ) — NUMBER(12) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SEND_MSG)
- Key (MSG_SEQ) — 기본 키 — NOT NULL
- (TO_USER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- (FROM_USER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- Field (MSG_CONTENT) — VARCHAR2(1000 BYTE)
- Field2 (SEND_DATE) — DATE
- Field (STATUS) — CHAR(1 BYTE)
Untitled (QNA_BOARD_FILE)
- Field (FILE_SEQ) — NUMBER(3,0) — 기본 키
- Key (QNA_SEQ2) — NUMBER(12,0) — 외래 키 → Untitled.Key — NOT NULL
- Field2 (FILE_NAME) — VARCHAR2(50 BYTE)
- Field3 (FILE_EXT) — VARCHAR2(20 BYTE)
- Field4 (FILE_SIZE) — NUMBER(12,0)
- Field (REG_DATE) — DATE
- Field (FILE_ORG_NAME) — VARCHAR2(100 BYTE)
Untitled (PAY_LIST)
- Key (ORDER_SEQ) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (PGTOKEN) — VARCHAR2(20 BYTE)
- Field2 (TOTAL_CNT) — NUMBER(12,0)
- Field (TOTAL_PRICE) — VARCHAR2(13 BYTE)
- Field (REG_DATE) — DATE
- Field (STATUS) — CHAR(1 BYTE)
- Field (PAY_METHOD) — VARCHAR2(40 BYTE)
Untitled (RESTO_FILE)
- Field (FILE_SEQ) — NUMBER(3) — 기본 키
- Key (R_SEQ) — VARCHAR(13) — 외래 키 → Untitled.Key — NOT NULL
- Field2 (FILE_NAME) — VARCHAR2(100)
Untitled (ORDER_LIST)
- Key (ORDER_SEQ) — VARCHAR2(20) — 기본 키 — NOT NULL
- Key (PRODUCT_SEQ) — VARCHAR2(13 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- (USER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- Field3 (REG_DATE) — DATE
- Field4 (STATUS) — CHAR(1 BYTE)
- Field (RESERV_DATE) — DATE
- Key (R_SEQ) — VARCHAR(13) — 외래 키 → Untitled.Key — NOT NULL
- Field (RESERV_TIME) — CHAR(5 BYTE)
- Field2 (RESERV_PERSON) — NUMBER(2,0)
- Field3 (REVIEWED) — CHAR(1 BYTE)
- Field4 (DELIVERY_STATUS) — CHAR(1 BYTE)
Untitled (MENU)
- Key (MENU_SEQ) — VARCHAR(13) — 기본 키 — NOT NULL
- Key (R_SEQ) — VARCHAR(13) — 외래 키 → Untitled.Key — NOT NULL
- Field (MENU_NAME) — VARCHAR2(150 BYTE)
- Field2 (MENU_PRICE) — VARCHAR2(12 BYTE)
- Field3 (MENU_CONTENT) — CLOB
Untitled (PRODUCT_INFO)
- Key (PRODUCT_SEQ) — VARCHAR(13) — 기본 키 — NOT NULL
- Key (SELLER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_SELLER.Key — NOT NULL
- Field (P_NAME) — VARCHAR2(150)
- Field2 (P_CONTENT) — CLOB
- Field3 (P_PRICE) — VARCHAR(12)
- Field4 (REG_DATE) — DATE
- Field5 (STATUS) — CHAR(1 BYTE)
- Field (PRODUCT_CATEGORY) — VARCHAR2(100 BYTE)
Untitled (RESTO_INFO)
- Key (R_SEQ) — VARCHAR(13) — 기본 키 — NOT NULL
- Field (RESTO_NAME) — VARCHAR2(100 BYTE)
- Key (SELLER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_SELLER.Key — NOT NULL
- Field2 (RESTO_ADDRESS) — VARCHAR2(200 BYTE)
- Field3 (RESTO_PH) — VARCHAR2(13 BYTE)
- Field4 (RSETO_CONTNENT) — CLOB
- Field5 (REG_DATE) — DATE
- Field (STATUS) — CHAR(1 BYTE)
- Field (RESTO_TYPE) — VARCHAR2(20 BYTE)
- Field2 (FOOD_TYPE) — VARCHAR2(10 BYTE)
- Field3 (RESTO_OFF) — VARCHAR2(18 BYTE)
- Field4 (RESTO_OPEN) — VARCHAR2(10 BYTE)
- Field5 (RESTO_CLOSE) — VARCHAR2(10 BYTE)
- Field (RESTO_DEPOSIT) — NUMBER(10,0)
- Field (LIMIT_PERSON) — NUMBER(2,0)
Untitled (NOTICE_BOARD)
- Key (BBS_SEQ) — NUMBER(12) — 기본 키 — NOT NULL
- (USER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- Field (BBS_TITLE) — VARCHAR2(150)
- Field2 (STATUS) — CHAR(1 BYTE)
- Field4 (REG_DATE) — DATE
- Field3 (BBS_CONTENT) — CLOB
Untitled (QNA_BOARD)
- Key (QNA_SEQ) — NUMBER(12,0) — 기본 키 — NOT NULL
- (USER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- Key (R_SEQ) — VARCHAR2(13 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- Key (PRODUCT_SEQ) — VARCHAR2(13 BYTE) — 외래 키 → Untitled.Key — NOT NULL
- Field (QNA_GROUP) — NUMBER(12,0)
- Field2 (QNA_ORDER) — NUMBER(10,0)
- Field3 (QNA_INTENT) — NUMBER(10,0)
- Field4 (QNA_TITLE) — VARCHAR2(150 BYTE)
- Field5 (QNA_CONTENT) — CLOB
- Field6 (QNA_PARENT) — NUMBER(12,0)
- Field7 (REG_DATE) — DATE
- Key (SELLER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_SELLER.Key — NOT NULL
Untitled (MAIN_BOARD_COMMENT)
- Key (COMMENT_SEQ) — NUMBER(12) — 기본 키 — NOT NULL
- Key (BOARD_SEQ) — NUMBER(12) — 외래 키 → Untitled.Key — NOT NULL
- Field (USER_ID) — VARCHAR2(20)
- Field2 (COMMENT_CONTENT) — CLOB
- Field3 (REG_DATE) — DATE
- Field (COMMENT_GROUP) — NUMBER(12,0)
- Field2 (COMMENT_ORDER) — NUMBER(10,0)
- Field (COMMENT_INDENT) — NUMBER(10,0)
- Field (COMMENT_PARENT) — NUMBER(12,0)
- Field2 (STATUS) — CHAR(1 BYTE)
Untitled (MAIN_BOARD)
- Key (BOARD_SEQ) — NUMBER(12) — 기본 키 — NOT NULL
- (USER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- Field (BOARD_TITLE) — VARCHAR2(300)
- Field2 (READ_CNT) — NUMBER(10)
- Field3 (REG_DATE) — DATE
- Field (STATUS) — CHAR(1)
- Field (BOARD_TYPE) — CLOB
Untitled (USER_PROFILE_FILE)
- (USER_ID) — VARCHAR2(20 BYTE) — 외래 키 → G2_USER.USER_ID — NOT NULL
- Field (FILE_NAME) — VARCHAR2(100 BYTE)
Untitled6 (ANNIVERSARY_SHARE)
- Key (ANNIVERSARY_SEQ) — NUMBER(12) — 외래 키 → USER_ANNIVERSARY.Key — NOT NULL
- Key (RELATIONAL_SEQ) — NUMBER(12) — 외래 키 → RELATIONAL_USER.Key — NOT NULL