학원프로젝트(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