rollcall
Tables (5)
Organization (조직)
- id (PK) — bigint — Primary key — NOT NULL
- name (Field) — varchar(50)
- intro (Field2) — varchar(300)
attendance (출석)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
- date (Field) — date
- start_time (Field2) — time
- total (Field3) — int
- status (Field4) — varchar(20)
inout (Untitled3)
- id (Key2) — bigint — Primary key — NOT NULL
- attendance_id (Key) — bigint — Foreign key → attendance.id — NOT NULL
- start_time (Field) — time
- end_time (Field2) — time
member (사용자)
- id (Key) — bigint — Primary key — NOT NULL
- member_num (Field) — bigint
- nickname (Field2) — varchar(50)
- password (Field3) — varchar(255)
- email (Field4) — varchar(100)
- phone (Field5) — varchar(50)
- gender (Field6) — varchar(10)
or_people (조직에 속한 사람들)
- id (Key) — bigint — Primary key — NOT NULL
- organization_id (PK) — bigint — Foreign key → Organization.id — NOT NULL
- member_id (Key2) — bigint — Foreign key → member.id — NOT NULL