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