team2
Tables (4)
chat_message
- id — BIGINT — Primary key — NOT NULL
- content — VARCHAR(255)
- timestamp — VARCHAR(255)
- receiver_id — BIGINT
- room_id — BIGINT
- sender_id — BIGINT
- INDEX — `FK46s59psfyf53qh0ayebjnn6tu`
- INDEX — `FKfvbc4wvhk51y0qtnjrbminxfu`
- INDEX — `FK5f82aoyy0jiwpj08qapfrxbh6`
chat_room
- id — bigint — Primary key — NOT NULL
- room_id — varchar(255)
- receiver_id — bigint
- sender_id — bigint
review
- review_id — INT — Primary key — NOT NULL
- marker_id — INT — NOT NULL
- user_id — BIGINT — NOT NULL
- rating — INT — NOT NULL
- comment — TEXT
- created_at — TIMESTAMP
- INDEX — `marker_id`
- INDEX — `user_id`
users
- seq — bigint — Primary key — NOT NULL
- address — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- loginid — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- pw — varchar(255) — NOT NULL
- role — varchar(255)
- tel — varchar(255) — NOT NULL