test
Tables (13)
belong
- user_id — varchar(100) — Primary key — NOT NULL
- organization_id — varchar(100) — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- is_authenticated — boolean — NOT NULL
block
- room_id — varchar(100) — Primary key — NOT NULL
- user_id — varchar(100) — Primary key — NOT NULL
crops
- id — varchar(100) — Primary key — NOT NULL
- user_id — varchar(100) — Primary key — NOT NULL
- type — crops_type — NOT NULL
- planted_at — timestamp(6) — NOT NULL
friend
- requester_id — varchar(100) — Primary key — NOT NULL
- acceptor_id — varchar(100) — Primary key — NOT NULL
- accepted — boolean — NOT NULL
- requested_at — timestamp(6) — NOT NULL
harvested_crops
- id — varchar(100) — Primary key — NOT NULL
- user_id — varchar(100) — Primary key — NOT NULL
- type — crops_type — NOT NULL
- harvested_at — timestamp(6) — NOT NULL
- grade — crops_type — NOT NULL
organization
- id — varchar(100) — NOT NULL
- name — varchar(30) — NOT NULL
- address — varchar(100) — NOT NULL
report
- id — varchar(100) — NOT NULL
- suspect_id — varchar(100) — NOT NULL
- reporter_id — varchar(100) — NOT NULL
- category — report_category — NOT NULL
- content — varchar(500) — NOT NULL
- reported_at — timestamp(6) — NOT NULL
- screenshot — varchar(500)
room
- id — varchar(100) — NOT NULL
- master_id — varchar(100) — NOT NULL
- title — varchar(50) — NOT NULL
- thumbnail — varchar(255)
- password — varchar(255)
- timer — integer — NOT NULL
- short_break — integer — NOT NULL
- long_break — integer — NOT NULL
- long_break_interval — integer — NOT NULL
- expired_at — timestamp(6) — NOT NULL
- deleted_at — timestamp(6)
room_tag
- tag_id — varchar(100) — Primary key — NOT NULL
- room_id — varchar(100) — Primary key — NOT NULL
study_history
- id — varchar(100) — Primary key — NOT NULL
- user_id — varchar(100) — Primary key — NOT NULL
- room_id — varchar(100) — Primary key — NOT NULL
- join_at — timestamp(6) — NOT NULL
- exit_at — timestamp(6)
tag
- id — varchar(100) — NOT NULL
- name — varchar(20) — NOT NULL
user_account
- id — varchar(100) — NOT NULL
- name — varchar(20) — NOT NULL
- introduce — varchar(100)
- score — bigint — NOT NULL
- profile_image — varchar(255)
- status — user_status — NOT NULL
user_tag
- tag_id — varchar(100) — Primary key — NOT NULL
- user_id — varchar(100) — Primary key — NOT NULL