spoontalk

Tables (6)

message

  • id — bigint(20) — Primary key — NOT NULL
  • content — varchar(255) — NOT NULL
  • evaluation_type — enum('EXCELLENT','IMPROVABLE') — NOT NULL
  • feedback_category — enum('FOOD','CLEAN','PRICE','SERVICE','ETC') — NOT NULL
  • status — enum('DELETED','READ','UNREAD') — NOT NULL
  • receiver_id — bigint(20) — NOT NULL
  • sender_id — bigint(20) — NOT NULL
  • store_id — bigint(20) — NOT NULL
  • is_del — bit(1)
  • created_at — datetime(6)
  • updated_at — datetime(6)

message_photo

  • id — bigint(20) — Primary key — NOT NULL
  • message_id — bigint(20) — Foreign key → message.id — NOT NULL
  • photo_name — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

opinion

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255) — NOT NULL
  • is_del — bit(1)
  • status — enum('DELETED','READ','UNREAD') — NOT NULL
  • title — varchar(255) — NOT NULL

store

  • id — bigint(20) — Primary key — NOT NULL
  • description — varchar(255)
  • location — varchar(255)
  • store_name — varchar(255) — NOT NULL
  • store_status — enum('CLOSE','COMING_SOON','OPEN','TEMP_CLOSED','UNDER_MAINTENANCE') — NOT NULL
  • tel — varchar(255)
  • owner_id — bigint(20)
  • open_time — time(6)
  • close_time — time(6)
  • is_del — bit(1)
  • created_at — datetime(6)
  • updated_at — datetime(6)

store_photo

  • id — bigint(20) — Primary key — NOT NULL
  • id (store_id) — bigint(20) — Foreign key → store.id — NOT NULL
  • photo_name — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

user

  • id — bigint(20) — Primary key — NOT NULL
  • user_name — varchar(255) — NOT NULL
  • login_id — varchar(255) — NOT NULL
  • login_password — varchar(255) — NOT NULL
  • address — varchar(255)
  • email — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • photo — varchar(255)
  • status_type — enum('ACTIVE','BANNED','INACTIVE') — NOT NULL
  • role — enum('ADMIN','CUSTOMER','GUEST','OWNER') — NOT NULL
  • is_auto_generated — bit(1)
  • is_blocked — bit(1)
  • is_del — bit(1)
  • created_at — datetime(6)
  • updated_at — datetime(6)