ㅂㅂㅂㅂ

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