B3
Tables (6)
bosses
- boss_id — INT — Primary key — NOT NULL
- user_name — VARCHAR(20)
- nick_name — VARCHAR(30)
- password — VARCHAR(60)
- address — VARCHAR(50)
- created_at — DATETIME
- role — ENUM
- state — INT
- siDo — VARCHAR(200)
- guGun — VARCHAR(200)
- dongEupMyeon — VARCHAR(200)
chat_rooms
- chat_room_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → bosses.boss_id — NOT NULL
- user_id (user_id2) — INT — Foreign key → bosses.boss_id — NOT NULL
- created_at — DATETIME
likes
- like_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → bosses.boss_id — NOT NULL
- restaurant_id — INT — Foreign key → restaurants.restaurant_id — NOT NULL
- created_at — DATETIME
messages
- Field — Primary key
- chat_room_id — INT — Foreign key → chat_rooms.chat_room_id — NOT NULL
- user_id (sender_id) — INT — Foreign key → bosses.boss_id — NOT NULL
- content — TEXT
- isRead — INT
- created_at — DATETIME
photos
- photo_id — INT — Primary key — NOT NULL
- s3Key — VARCHAR(500)
- s3Url — VARCHAR(500)
- originalFileName — VARCHAR(500)
- uploadDate — DATETIME
restaurants
- restaurant_id — INT — Primary key — NOT NULL
- boss_id — INT — Foreign key → bosses.boss_id — NOT NULL
- photo_id — INT — Foreign key → photos.photo_id — NOT NULL
- name — VARCHAR(30)
- address — VARCHAR(50)
- menu_name — VARCHAR(30)
- price — INT
- description — TEXT
- created_at — DATETIME
- updated_at — DATETIME
- state — INT
- siDo — VARCHAR(200)
- guGun — VARCHAR(200)
- dongEupMyeon — VARCHAR(200)