ㅂㅂㅂㅂ
Tables (8)
Board
- Board_Key — int — Primary key — NOT NULL
- Board_Name — varchar(10)
- Board_Date — date
ChatRoom
- ChatRoom_ID — bigint — Primary key — NOT NULL
- Sender_ID — bigint — NOT NULL
- Receiver_ID — bigint — NOT NULL
Comment
- Comment_ID — int — Primary key — NOT NULL
- Post_Num — int — NOT NULL
- Customer_ID — bigint — NOT NULL
- Comment_Content — varchar(1000) — NOT NULL
- Comment_Day — date
Customer
- Customer_ID — bigint — Primary key — NOT NULL
- Customer_Psw — varchar(20) — NOT NULL
- Customer_Name — varchar(10) — NOT NULL
- Customer_EMail — varchar(50) — NOT NULL
- Customer_Mobile_Number — char(11) — NOT NULL
- Customer_Favorites — varchar(100)
- Customer_Region — varchar(100) — NOT NULL
Lawyer
- Lawyer_ID — bigint — Foreign key → Customer.Customer_ID — NOT NULL
- Lawyer_Role — varchar(100) — NOT NULL
- Customer_ID — bigint — Foreign key → Customer.Customer_ID — NOT NULL
Message
- Message_ID — bigint — Primary key — NOT NULL
- Customer_ID — bigint — NOT NULL
- ChatRoom_ID — bigint — NOT NULL
- Msg_Content — varchar(255) — NOT NULL
- SendTime — timestamp — NOT NULL
Notification
- Notification_ID — bigint — Primary key — NOT NULL
- Customer_ID — bigint — NOT NULL
- Notification_Msg — varchar(255) — NOT NULL
- Notification_read_or_not — bool — NOT NULL
- Notification_type — enum('chat', 'offer') — NOT NULL
- Notification_reference — bigint — NOT NULL
- Notification_created_at — timestamp — NOT NULL
Post
- Post_Num — int — Primary key — NOT NULL
- Board_Key — int — NOT NULL
- Customer_ID — bigint — NOT NULL
- Lawyer_ID — bigint — NOT NULL
- Post_Title — varchar(100) — NOT NULL
- Post_Content — varchar(1000) — NOT NULL
- Post_Date — date — NOT NULL
- Post_Tag — varchar(10) — NOT NULL