GDJ77 semi

Tables (5)

Attach (attach_t)

  • Attach No (attach_no) — NUMBER — Primary key — NOT NULL
  • Upload Path (upload_path) — VARCHAR2(500)
  • Filesystem Name (filesystem_name) — VARCHAR2(500)
  • Original Filesystem (original_filesystem) — VARCHAR2(500)
  • Download Count (download_count) — NUMBER
  • Has Thumbnail (has_thumbnail) — NUMBER
  • Board No (board_no) — NUMBER — Foreign key → Board.Board No — NOT NULL

Board (board_t)

  • Board No (board_no) — NUMBER — Primary key — NOT NULL
  • User No (user_no2) — Int — Foreign key → USER.User No — NOT NULL
  • Title (title) — VARCHAR2(1000) — NOT NULL
  • Contents (contents) — CLOB
  • Hit (hit) — NUMBER — Default 0
  • Create Dt (create_dt) — TIMESTAMP
  • Modify Dt (modify_dt) — TIMESTAMP

Comment (comment_t)

  • Comment No (comment_no) — INT — Primary key — NOT NULL
  • User No (user_no2) — Int — Foreign key → USER.User No — NOT NULL
  • Contents (contents) — VARCHAR2(2000) — NOT NULL
  • Create Dt (create_dt) — TIMESTAMP — NOT NULL
  • State (state) — INT — NOT NULL
  • Depth (depth) — NUMBER — 원글0, 답글1
  • Group No (group_no) — NUMBER
  • Board No (board_no2) — NUMBER — Foreign key → Board.Board No — NOT NULL

Schedule (schedule_t)

  • ScheduleNo (schedule_no) — NUMBER — Primary key — NOT NULL
  • Title (title) — VARCHAR2(50 BYTE)
  • Reminder (reminder) — NUMBER
  • StartDate (startDate) — DATE
  • EndDate (endDate) — DATE
  • User No (user_no) — Int — Foreign key → USER.User No — NOT NULL

USER (user_t)

  • User No (user_no) — Int — Primary key — NOT NULL
  • Email (email) — VARCHAR2(100) — NOT NULL — UNIQUE
  • Pw (pw) — VARCHAR2(64)
  • Name (name) — VARCHAR2(100)
  • Gender (gender) — VARCHAR2(5)
  • Mobile (mobile) — VARCHAR2(20)
  • Employee Id (employee_id) — VARCHAR2(10)
  • Pw Modify Dt (pw_modify_dt) — DATE
  • Signup Dt (signup_dt) — DATE