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