weddingcard

테이블 (3)

결혼식 정보 (T_WEDDING_INFO)

  • Key (WEDDING_ID) — INT — 기본 키 — NOT NULL
  • Field (WEDDING_DATE) — DATETIME
  • Field (WEDDING_HALL_LOCATION) — VARCHAR

관리자 계정 테이블 (T_MNGR_INFO)

  • Key (MNGR_ID) — INT — 기본 키 — NOT NULL
  • Field (MNGR_NAME) — CHAR(5)
  • Field (MNGR_ACCOUNT) — CHAR(15)
  • Field (MNGR_PASSWORD) — VARCHAR
  • Field (MNGR_MAC) — VARCHAR\
  • Field (CREATE_DATE) — DATETIME
  • Field2 (LAST_MODIFIED_DATE) — DATETIME

댓글 테이블 (T_CONG_COMENT)

  • Key (COMENT_ID) — INT — 기본 키 — NOT NULL
  • Field (TITLE) — VARCHAR(100)
  • Field (CONTENT) — VARCHAR
  • Field (PASSWORD) — VARCHAR
  • Field (DELETE_YN) — CHAR(1)
  • Field (CREATE_ID) — CHAR(15)
  • Field2 (CREATE_DATE) — DATETIME
  • Field (LAST_MODIFIED_ID) — CHAR(15)
  • Field (LAST_MODIFIED_DATE) — DATETIME