moai
Tables (8)
calander_share_users (Untitled5)
- calander_id (Key2) — int8 — Foreign key → calanders.user_id — NOT NULL
- user_id (Key) — varchar(50) — Foreign key → users.user_id — NOT NULL
calanders (Untitled2)
- calander_id (Key) — int8 — Primary key — NOT NULL
- user_id (Key2) — varchar(50) — Foreign key → users.user_id — NOT NULL
- start_date (Field) — datetime — NOT NULL
- end_date (Field2) — datetime
- title (Field3) — varchar(255) — NOT NULL
chat_logs (Untitled3)
- chat_id (Key) — int8 — Primary key — NOT NULL
- user_id (Key2) — varchar(50) — Foreign key → users.user_id — NOT NULL
- room_id (Key3) — int8 — Foreign key → rooms.room_id — NOT NULL
- chat_at (Field) — timestamp
- chat (Field4) — varchar
group_join_users (Untitled9)
- user_id (Key) — varchar(50) — Foreign key → users.user_id — NOT NULL
- group_id (Key2) — int8 — Foreign key → groups.group_id — NOT NULL
groups (Untitled8)
- group_id (Key) — int8 — Primary key — NOT NULL
- group_name (Field) — varchar
room_users (Untitled7)
- user_id (Key) — varchar(50) — Foreign key → users.user_id — NOT NULL
- room_id (Key2) — int8 — Foreign key → rooms.room_id — NOT NULL
rooms (Untitled4)
- room_id (Key) — int8 — Primary key — NOT NULL
- create_at (Field) — timestamp
users (Untitled)
- user_id (Key) — varchar(50) — Primary key — NOT NULL
- name (Field2) — varchar(50) — NOT NULL
- job_id (Field3) — varchar(50) — NOT NULL
- user_pw (Field) — varchar(50) — NOT NULL