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