mojal

Tables (11)

Chat_contents

  • chat_idx (Key) — Primary key — NOT NULL
  • user_id (Field) — varchar(30)
  • chat_id (Field2) — varchar(30)
  • send_time (Field3) — varchar(30)
  • confirm_bool (Field4) — boolean

Chat_room

  • idx (Key) — INT — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • status (Field2) — varchar(50)
  • make_time (Field3) — datatime
  • Field4
  • idx (Key2) — INT — Foreign key → USER.idx — NOT NULL
  • chat_idx (Key3) — Foreign key → Chat_contents.chat_idx — NOT NULL
  • chat_idx (Key4) — Foreign key → Chat_contents.chat_idx — NOT NULL

Exchange_POST

  • idx (Key) — Primary key — NOT NULL
  • Field

FREE_POST

  • idx (Key) — INT — Primary key — NOT NULL
  • Field

HEADCOUNT

  • post_idx (Key) — INT — Primary key — NOT NULL
  • max_capacity (Field) — INT
  • current_count_capacity (Field2)
  • idx (Key2) — INT — Foreign key → POST.idx — NOT NULL
  • Key4 — Foreign key → POST.Key4 — NOT NULL

POST

  • idx (Key) — INT — Primary key — NOT NULL
  • Key4 (FK) — boolean — Primary key — NOT NULL
  • give_btm_category (Field4) — varchar(20)
  • user_idx (Field) — INT
  • title (Field2) — varchar(30)
  • give_top_category (Field3) — varchar(20)
  • top_category (Field5) — varchar(20)
  • btm_category (Field6) — varchar(20)
  • capacity (Field7) — INT
  • end_date (Field8) — datetime
  • contents (Field9) — varchar(1000)
  • write_datetime (Field10) — datetime
  • update_datetime (Field11) — datetime
  • idx (Key2) — INT — Foreign key → USER.idx — NOT NULL
  • idx (Key3) — INT — Foreign key → TOP_Category.idx — NOT NULL
  • type (Field12) — boolean — NOT NULL
  • Field13

POST_MATCHING_USER

  • idx (Key) — INT — Primary key — NOT NULL
  • matching_idx (Field) — INT
  • post_idx (Field2) — INT
  • Field3
  • idx (Key2) — INT — Foreign key → POST.idx — NOT NULL
  • Key4 — Foreign key → POST.Key4 — NOT NULL

POST_STATUS

  • idx (Key) — INT — Primary key — NOT NULL
  • status1 (Field) — varchar(10)
  • status2 (Field2) — varchar(10)
  • status3 (Field3) — varchar(10)
  • idx (Key2) — INT — Foreign key → POST.idx — NOT NULL
  • Key4 — Foreign key → POST.Key4 — NOT NULL
  • post_idx (Key3) — INT — Foreign key → HEADCOUNT.post_idx — NOT NULL

TOP_Category (Top_Category)

  • idx (Key) — INT — Primary key — NOT NULL
  • name (Field) — varchar(30)
  • Field2

USER

  • idx (Key) — INT — Primary key — NOT NULL
  • nickname (Field2) — varchar(30)
  • email (Field3) — varchar(30)
  • password (Field5) — varchar(30)
  • signup_date (Field6) — DATETIME()

chat_user

  • user_id (Key) — INT — Primary key — NOT NULL
  • room_id (Key2) — INT\ — Primary key — NOT NULL