han_batang_nollja

Tables (10)

Certification (certification)

  • user_id (Primary key) — VARCHAR(30) — Primary key — NOT NULL
  • email (Field1) — VARCHAR(255)
  • certification_number (Field2) — VARCHAR(4)

Chat Room (chat_room)

  • chat_room_id (Primary key) — INT — Primary key — NOT NULL
  • chat_room_name (Field1) — VARCHAR(30)
  • chat_room_generated_date (Field2) — DATE
  • chat_room_status (Field3) — BOOLEAN
  • is_for_invitation (Field4) — BOOLEAN

Club (club)

  • club_id (Primary key) — INT — Primary key — NOT NULL
  • club_title (Field1) — VARCHAR(30)
  • club_thumbnail_url (Field2) — URL
  • club_short_intro (Field3) — VARCHAR(155)
  • club_member_requirements (Field4) — TEXT
  • club_activity_description (Field5) — TEXT
  • club_current_member_num (Field6) — INT
  • club_page_visited_num (Field7) — INT
  • clubCreatedDate (Field8) — DATE

Club Info (club_info)

  • club_info_id (Primary key) — INT — Primary key — NOT NULL
  • club_id (Foreign key) — INT — Foreign key → Club.club_id — NOT NULL
  • club_type (Field1) — VARCHAR(30)
  • club_location (Field2) — VARCHAR(30)
  • club_total_num (Field3) — INT

Club Member (club_member)

  • club_member_id (Primary key) — INT — Primary key — NOT NULL
  • club_id (Primary key1) — INT — Foreign key → Club.club_id — NOT NULL
  • user_id (Primary key2) — VARCHAR(30) — Foreign key → User.user_id — NOT NULL
  • is_admin (Field1) — BOOLEAN
  • is_joined (Field2) — BOOLEAN

Join Chat (join_chat)

  • chat_generated_id (Primary key) — INT — Primary key — NOT NULL
  • chat_room_id (Foreign key) — VARCHAR(30) — Foreign key → Chat Room.chat_room_id — NOT NULL
  • user_id (Foreigen key1) — VARCHAR(30) — Foreign key → User.user_id — NOT NULL
  • is_permitted (Field) — BOOLEAN
  • sender (Field2) — VARCHAR(30)
  • sender_thumbnail_url (Field3) — VARCHAR(255)

Message (message)

  • message_id (Primary key) — INT — Primary key — NOT NULL
  • chat_generated_id (Foreign key) — INT — Foreign key → Join Chat.chat_generated_id — NOT NULL
  • messages_text (Field1) — VARCHAR(255)
  • messages_sent_time (Field2) — DATE

Notification (notification)

  • notification_id (Primary key) — INT — Primary key — NOT NULL
  • chat_generated_id (Primary key2) — INT — Foreign key → Join Chat.chat_generated_id — NOT NULL
  • notification_content (Field) — VARCHAR(100)
  • notification_sent_time (Field2) — DATE
  • is_read (Field3) — BOOLEAN
  • stacks (Field4) — INT
  • route (Field5) — VARCHAR(255)

User (user)

  • user_id (Primary key) — VARCHAR(30) — Primary key — NOT NULL
  • password (Field1) — VARCHAR(255)
  • email (Field2) — VARCHAR(255)

User Info (user_info)

  • user_info_id (Primary key) — INT — Primary key — NOT NULL
  • user_id (Foreign key) — VARCHAR(30) — Foreign key → User.user_id — NOT NULL
  • nick_name (Field1) — VARCHAR(30)
  • age (Field2) — INT
  • short_intro (Field3) — VARCHAR(255)
  • user_thumbnail_url (Field4) — URL