giggle
Tables (25)
Account (계정)
- account_id (ㄹ) — Primary key — NOT NULL
- login_id (Field)
- password (Field2)
- name (Field11)
- employee_no (Field3)
- birthday (Field4)
- phone (Field5)
- email (Field6)
- join_date (Field7)
- left_date (Field8)
- address (Field9)
- introduction (Field10)
- part (Field12)
- duty (Field13)
- status (Field15)
- work (Field16)
- role_id (Key) — Foreign key → Role.role_id — NOT NULL
- attach_id (Key2) — Foreign key → Attach.attach_id — NOT NULL
- created_by (Field14)
- created_at (Field17)
Account_Team (Untitled2)
- team_id (Key) — Foreign key → Team.team_id — NOT NULL
- account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL
Annual (Untitled28)
- annual_id (Key) — Primary key — NOT NULL
- created_by (Field4)
- created_at (Field5)
- total_annual (Field)
- reamining_annual (Field2)
Annual_History (CopyOfUntitled28)
- annul_history_id (Key) — Primary key — NOT NULL
- title (Field)
- type (Field2)
- division (Field3)
- created_by (Field4)
- created_at (Field5)
- annual_id (Key2) — Foreign key → Annual.annual_id — NOT NULL
- vacation_id (Key3) — Foreign key → Vacation.vacation_id — NOT NULL
Attach (Untitled4)
- attach_id (Key) — Primary key — NOT NULL
- filePath (Field)
- fileName (Field2)
Comment (Untitled6)
- comment_id (Key) — Primary key — NOT NULL
- content (Field)
- created_by (Field2)
- created_at (Field3)
Comment_King (Untitled26)
- photo_comment_king_id (Key) — Primary key — NOT NULL
- comment_count (Field)
- account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL
Event (Untitled13)
- event_id (Key) — Primary key — NOT NULL
- title (Field)
- type (Field2)
- content (Field3)
- start_date (Field4)
- end_date (Field5)
- is_all_day (Field6)
- start_time (Field7)
- end_time (Field8)
- created_by (Field9)
- created_at (Field10)
Nicedain (Untitled31)
- nicedain_id (Key) — Primary key — NOT NULL
- account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL
- date (Field)
Notice (Untitled5)
- notice_id (Key) — Primary key — NOT NULL
- title (Field)
- content (Field2)
- created_by (Field4)
- created_at (Field5)
- attach_id (Key2) — Foreign key → Attach.attach_id — NOT NULL
Notice_Comment (Untitled7)
- notice_id (Key) — Foreign key → Notice.notice_id — NOT NULL
- comment_id (Key2) — Foreign key → Comment.comment_id — NOT NULL
Notice_Like (Untitled8)
- notice_id (Key) — Foreign key → Notice.notice_id — NOT NULL
- account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL
Overtime (Untitled22)
- overtime_id (Key) — Primary key — NOT NULL
- title (Field)
- content (Field2)
- overtime_date (Field3)
- status (Field4)
- created_by (Field5)
- created_at (Field6)
Photo_Board (Untitled9)
- photo_id (Key) — Primary key — NOT NULL
- title (Field)
- content (Field2)
- created_by (Field3)
- created_at (Field4)
- attach_id (Key2) — Foreign key → Attach.attach_id — NOT NULL
Photo_Comment (Untitled11)
- photo_id (Key) — Foreign key → Photo_Board.photo_id — NOT NULL
- comment_id (Key2) — Foreign key → Comment.comment_id — NOT NULL
Photo_King (CopyOfUntitled26)
- photo_comment_king_id (Key) — Primary key — NOT NULL
- photo_count (Field2)
- account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL
Photo_Like (Untitled12)
- photo_id (Key) — Foreign key → Photo_Board.photo_id — NOT NULL
- account_id (ㄹ) — Foreign key → Account.account_id — NOT NULL
Request (Untitled14)
- request_id (Key) — Primary key — NOT NULL
- title (Field)
- request_type (Field2)
- content (Field3)
- status (Field4)
- created_by (Field5)
- created_at (Field6)
- approval_at (Field7)
Role (Untitled3)
- role_id (Key) — Primary key — NOT NULL
- name (Field)
Sign (Untitled15)
- sign_id (Key) — Primary key — NOT NULL
- signatory (Field)
- orders (Field2)
- status (Field3)
- request_id (Key2) — Foreign key → Request.request_id — NOT NULL
- vacation_id (Key3) — Foreign key → Vacation.vacation_id — NOT NULL
- overtime_id (Key4) — Foreign key → Overtime.overtime_id — NOT NULL
Talk (Untitled30)
- talk_id (Key) — Primary key — NOT NULL
- content (Field)
- created_by (Field3)
Team (Untitled)
- team_id (Key) — Primary key — NOT NULL
- name (Field)
- leader (Field2)
Vacation (Untitled19)
- vacation_id (Key) — Primary key — NOT NULL
- title (Field)
- content (Field5)
- vacation_type (Field2)
- status (Field8)
- start_date (Field3)
- end_date (Field4)
- created_by (Field6)
- created_at (Field7)
Work (Untitled17)
- work_id (Key) — Primary key — NOT NULL
- type (Field)
- work_date (Field2)
- created_by (Field4)
- created_at (Field3)
Wrap_Comment (Untitled27)
- wrap_comment (Key) — Primary key — NOT NULL
- content (Field)
- created_by (Field2)
- created_at (Field3)