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)