semi
Tables (7)
board
- board no (board_no) — bigint — Primary key — NOT NULL
- user id (user_id) — varchar(20) — Foreign key → user.user id — NOT NULL
- title — varchar(100)
- content — text
- create at (create_at) — dateTime
- update at (update_at) — dateTime
- Field
comment
- comment no (comment_no) — bigint — Primary key — NOT NULL
- user id (user_id2) — varchar(20) — Foreign key → user.user id — NOT NULL
- content — varchar(100)
- create at (create_at) — dateTime
- update at (update_at) — dateTime
- board no (board_no) — bigint — Foreign key → board.board no — NOT NULL
- user id (user_id) — varchar(20) — Foreign key → board.user id — NOT NULL
follows
- follower_id — Primary key — NOT NULL
- following_id — Primary key — NOT NULL
- created_at — dateTime
item
- item no (item_no) — bigint — Primary key — NOT NULL
- user id (user_id) — varchar(20) — Primary key — NOT NULL
- item title (item_title) — varchar(50)
- category — varchar(20)
- start at (start_at) — dateTime
- end at (end_at) — dateTime
- is confirmed (is_confirmed) — char
- is cancelled (is_cancelled) — char
- total people (total_people) — int
price_policies
- price id (price_id) — varchar(100) — Primary key — NOT NULL
- name — varchar(100) — Primary key
- base price (base_price) — int
- min count (min_count) — int
- max count (max_count) — int
- is holiday (is_holiday) — char
role
- role id (role_id) — varchar(10) — Primary key — NOT NULL
- role name (role_name) — varchar(10) — NOT NULL
user
- user id (user_id) — varchar(20) — Primary key — NOT NULL
- user password (user_password) — varchar(20)
- email — varchar(50)
- createat (Create_at) — dateTime
- user status (user_status) — varchar(2)
- profile — json